SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO
CREATE VIEW dbo.vweCongresosSeminarios
AS
SELECT IdCongresoSeminario AS ID, Agente, Duracion, UnidadDeTiempo, TipoDeEvento, TipoDeParticipacion, DescripcionDelEvento, EntidadOrganizadora, 
               TipoEntidad, FechaDelEvento, GrupoIncumbencias, FechaPresentacion
FROM  dbo.tb_CongresosSeminarios
GO
GRANT SELECT ON  [dbo].[vweCongresosSeminarios] TO [Juntas]
GRANT INSERT ON  [dbo].[vweCongresosSeminarios] TO [Juntas]
GRANT DELETE ON  [dbo].[vweCongresosSeminarios] TO [Juntas]
GRANT UPDATE ON  [dbo].[vweCongresosSeminarios] TO [Juntas]
GRANT SELECT ON  [dbo].[vweCongresosSeminarios] TO [MCEEjecutivo]
GRANT SELECT ON  [dbo].[vweCongresosSeminarios] TO [PersonalDocenteDireccion]
GRANT SELECT ON  [dbo].[vweCongresosSeminarios] TO [SoloVer]
GO
